Tabela Address

Definicja tabeli Address

Name

Address

Code

Address

Comment

PL: Tabela adresów
EN: Address table
DE: Die Tabelle fur die Adresse


Lista kolumn tabeli Address

Name

Code

AddressID

AddressID

AddressTypeID

AddressTypeID

CountryID

CountryID

AdmCodeID

AdmCodeID

Street

Street

HomeNo

HomeNo

FlatNo

FlatNo

PostalCode

PostalCode

PostOffice

PostOffice

Place

Place

Phone

Phone

Fax

Fax

Email

Email

www

www

Telex

Telex

Detailed

Detailed

DescriptiveAddress

DescriptiveAddress

CommuneID

CommuneID

DistrictID

DistrictID

VoivodshipID

VoivodshipID


Kolumna AddressID tabeli Address

Definicja kolumny AddressID tabeli Address

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AddressTypeID tabeli Address

Definicja kolumny AddressTypeID tabeli Address

Name

AddressTypeID

Code

AddressTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CountryID tabeli Address

Definicja kolumny CountryID tabeli Address

Name

CountryID

Code

CountryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AdmCodeID tabeli Address

Definicja kolumny AdmCodeID tabeli Address

Name

AdmCodeID

Code

AdmCodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Street tabeli Address

Definicja kolumny Street tabeli Address

Name

Street

Code

Street

Data Type

VARCHAR2(241)

Mandatory

No

Comment

Ulica


Kolumna HomeNo tabeli Address

Definicja kolumny HomeNo tabeli Address

Name

HomeNo

Code

HomeNo

Data Type

VARCHAR2(9)

Mandatory

No

Comment

Numer domu


Kolumna FlatNo tabeli Address

Definicja kolumny FlatNo tabeli Address

Name

FlatNo

Code

FlatNo

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Numer lokalu


Kolumna PostalCode tabeli Address

Definicja kolumny PostalCode tabeli Address

Name

PostalCode

Code

PostalCode

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Kod pocztowy, jezeli wystepuje


Kolumna PostOffice tabeli Address

Definicja kolumny PostOffice tabeli Address

Name

PostOffice

Code

PostOffice

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna Place tabeli Address

Definicja kolumny Place tabeli Address

Name

Place

Code

Place

Data Type

VARCHAR2(100)

Mandatory

No

Comment

Miejscowosc zamieszkania


Kolumna Phone tabeli Address

Definicja kolumny Phone tabeli Address

Name

Phone

Code

Phone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Fax tabeli Address

Definicja kolumny Fax tabeli Address

Name

Fax

Code

Fax

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Email tabeli Address

Definicja kolumny Email tabeli Address

Name

Email

Code

Email

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna www tabeli Address

Definicja kolumny www tabeli Address

Name

www

Code

www

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Telex tabeli Address

Definicja kolumny Telex tabeli Address

Name

Telex

Code

Telex

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Detailed tabeli Address

Definicja kolumny Detailed tabeli Address

Name

Detailed

Code

Detailed

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna DescriptiveAddress tabeli Address

Definicja kolumny DescriptiveAddress tabeli Address

Name

DescriptiveAddress

Code

DescriptiveAddress

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna CommuneID tabeli Address

Definicja kolumny CommuneID tabeli Address

Name

CommuneID

Code

CommuneID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DistrictID tabeli Address

Definicja kolumny DistrictID tabeli Address

Name

DistrictID

Code

DistrictID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VoivodshipID tabeli Address

Definicja kolumny VoivodshipID tabeli Address

Name

VoivodshipID

Code

VoivodshipID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli Address

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Address

Definicja klucza Identifier_1 tabeli Address

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment